Problem Note 20874: Import Data task might return missing values in first row within SAS® Enterprise Guide®
The Import Data task might return missing values in the first row when
importing a PC file such as a Microsoft Excel file. The problem will
most likely occur for PC files that do not have column names and, most
likely, just for the numeric columns in the file.
To circumvent the problem, add column names to the PC file in the native
application before importing the data.
If your PC Files do not have column names, and you do not want to add
column names as mentioned in the prior circumvention, here is an
alternative circumvention:
1. Access the PC registry using Start => Run => REGEDIT.
2. Drill down to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
3. Change FirstRowHasNames from 01 to 00.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft Windows XP Professional | 4.1 | 4.2 | 9.1 TS1M3 SP1 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2007-09-11 18:52:29 |
| Date Created: | 2007-08-31 13:05:10 |
